package com.base.po.replacement;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class ReplacementBankCardExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public ReplacementBankCardExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("ID is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("ID is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(String value) {
            addCriterion("ID =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(String value) {
            addCriterion("ID <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(String value) {
            addCriterion("ID >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(String value) {
            addCriterion("ID >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(String value) {
            addCriterion("ID <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(String value) {
            addCriterion("ID <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLike(String value) {
            addCriterion("ID like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotLike(String value) {
            addCriterion("ID not like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<String> values) {
            addCriterion("ID in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<String> values) {
            addCriterion("ID not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(String value1, String value2) {
            addCriterion("ID between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(String value1, String value2) {
            addCriterion("ID not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andUseridIsNull() {
            addCriterion("UserID is null");
            return (Criteria) this;
        }

        public Criteria andUseridIsNotNull() {
            addCriterion("UserID is not null");
            return (Criteria) this;
        }

        public Criteria andUseridEqualTo(String value) {
            addCriterion("UserID =", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotEqualTo(String value) {
            addCriterion("UserID <>", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThan(String value) {
            addCriterion("UserID >", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThanOrEqualTo(String value) {
            addCriterion("UserID >=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThan(String value) {
            addCriterion("UserID <", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThanOrEqualTo(String value) {
            addCriterion("UserID <=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLike(String value) {
            addCriterion("UserID like", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotLike(String value) {
            addCriterion("UserID not like", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridIn(List<String> values) {
            addCriterion("UserID in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotIn(List<String> values) {
            addCriterion("UserID not in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridBetween(String value1, String value2) {
            addCriterion("UserID between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotBetween(String value1, String value2) {
            addCriterion("UserID not between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andUsernameIsNull() {
            addCriterion("UserName is null");
            return (Criteria) this;
        }

        public Criteria andUsernameIsNotNull() {
            addCriterion("UserName is not null");
            return (Criteria) this;
        }

        public Criteria andUsernameEqualTo(String value) {
            addCriterion("UserName =", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameNotEqualTo(String value) {
            addCriterion("UserName <>", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameGreaterThan(String value) {
            addCriterion("UserName >", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameGreaterThanOrEqualTo(String value) {
            addCriterion("UserName >=", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameLessThan(String value) {
            addCriterion("UserName <", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameLessThanOrEqualTo(String value) {
            addCriterion("UserName <=", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameLike(String value) {
            addCriterion("UserName like", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameNotLike(String value) {
            addCriterion("UserName not like", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameIn(List<String> values) {
            addCriterion("UserName in", values, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameNotIn(List<String> values) {
            addCriterion("UserName not in", values, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameBetween(String value1, String value2) {
            addCriterion("UserName between", value1, value2, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameNotBetween(String value1, String value2) {
            addCriterion("UserName not between", value1, value2, "username");
            return (Criteria) this;
        }

        public Criteria andIdnoIsNull() {
            addCriterion("IdNo is null");
            return (Criteria) this;
        }

        public Criteria andIdnoIsNotNull() {
            addCriterion("IdNo is not null");
            return (Criteria) this;
        }

        public Criteria andIdnoEqualTo(String value) {
            addCriterion("IdNo =", value, "idno");
            return (Criteria) this;
        }

        public Criteria andIdnoNotEqualTo(String value) {
            addCriterion("IdNo <>", value, "idno");
            return (Criteria) this;
        }

        public Criteria andIdnoGreaterThan(String value) {
            addCriterion("IdNo >", value, "idno");
            return (Criteria) this;
        }

        public Criteria andIdnoGreaterThanOrEqualTo(String value) {
            addCriterion("IdNo >=", value, "idno");
            return (Criteria) this;
        }

        public Criteria andIdnoLessThan(String value) {
            addCriterion("IdNo <", value, "idno");
            return (Criteria) this;
        }

        public Criteria andIdnoLessThanOrEqualTo(String value) {
            addCriterion("IdNo <=", value, "idno");
            return (Criteria) this;
        }

        public Criteria andIdnoLike(String value) {
            addCriterion("IdNo like", value, "idno");
            return (Criteria) this;
        }

        public Criteria andIdnoNotLike(String value) {
            addCriterion("IdNo not like", value, "idno");
            return (Criteria) this;
        }

        public Criteria andIdnoIn(List<String> values) {
            addCriterion("IdNo in", values, "idno");
            return (Criteria) this;
        }

        public Criteria andIdnoNotIn(List<String> values) {
            addCriterion("IdNo not in", values, "idno");
            return (Criteria) this;
        }

        public Criteria andIdnoBetween(String value1, String value2) {
            addCriterion("IdNo between", value1, value2, "idno");
            return (Criteria) this;
        }

        public Criteria andIdnoNotBetween(String value1, String value2) {
            addCriterion("IdNo not between", value1, value2, "idno");
            return (Criteria) this;
        }

        public Criteria andCardnoIsNull() {
            addCriterion("CardNo is null");
            return (Criteria) this;
        }

        public Criteria andCardnoIsNotNull() {
            addCriterion("CardNo is not null");
            return (Criteria) this;
        }

        public Criteria andCardnoEqualTo(String value) {
            addCriterion("CardNo =", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoNotEqualTo(String value) {
            addCriterion("CardNo <>", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoGreaterThan(String value) {
            addCriterion("CardNo >", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoGreaterThanOrEqualTo(String value) {
            addCriterion("CardNo >=", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoLessThan(String value) {
            addCriterion("CardNo <", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoLessThanOrEqualTo(String value) {
            addCriterion("CardNo <=", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoLike(String value) {
            addCriterion("CardNo like", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoNotLike(String value) {
            addCriterion("CardNo not like", value, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoIn(List<String> values) {
            addCriterion("CardNo in", values, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoNotIn(List<String> values) {
            addCriterion("CardNo not in", values, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoBetween(String value1, String value2) {
            addCriterion("CardNo between", value1, value2, "cardno");
            return (Criteria) this;
        }

        public Criteria andCardnoNotBetween(String value1, String value2) {
            addCriterion("CardNo not between", value1, value2, "cardno");
            return (Criteria) this;
        }

        public Criteria andPhoneIsNull() {
            addCriterion("Phone is null");
            return (Criteria) this;
        }

        public Criteria andPhoneIsNotNull() {
            addCriterion("Phone is not null");
            return (Criteria) this;
        }

        public Criteria andPhoneEqualTo(String value) {
            addCriterion("Phone =", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotEqualTo(String value) {
            addCriterion("Phone <>", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneGreaterThan(String value) {
            addCriterion("Phone >", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneGreaterThanOrEqualTo(String value) {
            addCriterion("Phone >=", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneLessThan(String value) {
            addCriterion("Phone <", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneLessThanOrEqualTo(String value) {
            addCriterion("Phone <=", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneLike(String value) {
            addCriterion("Phone like", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotLike(String value) {
            addCriterion("Phone not like", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneIn(List<String> values) {
            addCriterion("Phone in", values, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotIn(List<String> values) {
            addCriterion("Phone not in", values, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneBetween(String value1, String value2) {
            addCriterion("Phone between", value1, value2, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotBetween(String value1, String value2) {
            addCriterion("Phone not between", value1, value2, "phone");
            return (Criteria) this;
        }

        public Criteria andBanknameIsNull() {
            addCriterion("BankName is null");
            return (Criteria) this;
        }

        public Criteria andBanknameIsNotNull() {
            addCriterion("BankName is not null");
            return (Criteria) this;
        }

        public Criteria andBanknameEqualTo(String value) {
            addCriterion("BankName =", value, "bankname");
            return (Criteria) this;
        }

        public Criteria andBanknameNotEqualTo(String value) {
            addCriterion("BankName <>", value, "bankname");
            return (Criteria) this;
        }

        public Criteria andBanknameGreaterThan(String value) {
            addCriterion("BankName >", value, "bankname");
            return (Criteria) this;
        }

        public Criteria andBanknameGreaterThanOrEqualTo(String value) {
            addCriterion("BankName >=", value, "bankname");
            return (Criteria) this;
        }

        public Criteria andBanknameLessThan(String value) {
            addCriterion("BankName <", value, "bankname");
            return (Criteria) this;
        }

        public Criteria andBanknameLessThanOrEqualTo(String value) {
            addCriterion("BankName <=", value, "bankname");
            return (Criteria) this;
        }

        public Criteria andBanknameLike(String value) {
            addCriterion("BankName like", value, "bankname");
            return (Criteria) this;
        }

        public Criteria andBanknameNotLike(String value) {
            addCriterion("BankName not like", value, "bankname");
            return (Criteria) this;
        }

        public Criteria andBanknameIn(List<String> values) {
            addCriterion("BankName in", values, "bankname");
            return (Criteria) this;
        }

        public Criteria andBanknameNotIn(List<String> values) {
            addCriterion("BankName not in", values, "bankname");
            return (Criteria) this;
        }

        public Criteria andBanknameBetween(String value1, String value2) {
            addCriterion("BankName between", value1, value2, "bankname");
            return (Criteria) this;
        }

        public Criteria andBanknameNotBetween(String value1, String value2) {
            addCriterion("BankName not between", value1, value2, "bankname");
            return (Criteria) this;
        }

        public Criteria andBankbranchIsNull() {
            addCriterion("BankBranch is null");
            return (Criteria) this;
        }

        public Criteria andBankbranchIsNotNull() {
            addCriterion("BankBranch is not null");
            return (Criteria) this;
        }

        public Criteria andBankbranchEqualTo(String value) {
            addCriterion("BankBranch =", value, "bankbranch");
            return (Criteria) this;
        }

        public Criteria andBankbranchNotEqualTo(String value) {
            addCriterion("BankBranch <>", value, "bankbranch");
            return (Criteria) this;
        }

        public Criteria andBankbranchGreaterThan(String value) {
            addCriterion("BankBranch >", value, "bankbranch");
            return (Criteria) this;
        }

        public Criteria andBankbranchGreaterThanOrEqualTo(String value) {
            addCriterion("BankBranch >=", value, "bankbranch");
            return (Criteria) this;
        }

        public Criteria andBankbranchLessThan(String value) {
            addCriterion("BankBranch <", value, "bankbranch");
            return (Criteria) this;
        }

        public Criteria andBankbranchLessThanOrEqualTo(String value) {
            addCriterion("BankBranch <=", value, "bankbranch");
            return (Criteria) this;
        }

        public Criteria andBankbranchLike(String value) {
            addCriterion("BankBranch like", value, "bankbranch");
            return (Criteria) this;
        }

        public Criteria andBankbranchNotLike(String value) {
            addCriterion("BankBranch not like", value, "bankbranch");
            return (Criteria) this;
        }

        public Criteria andBankbranchIn(List<String> values) {
            addCriterion("BankBranch in", values, "bankbranch");
            return (Criteria) this;
        }

        public Criteria andBankbranchNotIn(List<String> values) {
            addCriterion("BankBranch not in", values, "bankbranch");
            return (Criteria) this;
        }

        public Criteria andBankbranchBetween(String value1, String value2) {
            addCriterion("BankBranch between", value1, value2, "bankbranch");
            return (Criteria) this;
        }

        public Criteria andBankbranchNotBetween(String value1, String value2) {
            addCriterion("BankBranch not between", value1, value2, "bankbranch");
            return (Criteria) this;
        }

        public Criteria andBankcodeIsNull() {
            addCriterion("BankCode is null");
            return (Criteria) this;
        }

        public Criteria andBankcodeIsNotNull() {
            addCriterion("BankCode is not null");
            return (Criteria) this;
        }

        public Criteria andBankcodeEqualTo(String value) {
            addCriterion("BankCode =", value, "bankcode");
            return (Criteria) this;
        }

        public Criteria andBankcodeNotEqualTo(String value) {
            addCriterion("BankCode <>", value, "bankcode");
            return (Criteria) this;
        }

        public Criteria andBankcodeGreaterThan(String value) {
            addCriterion("BankCode >", value, "bankcode");
            return (Criteria) this;
        }

        public Criteria andBankcodeGreaterThanOrEqualTo(String value) {
            addCriterion("BankCode >=", value, "bankcode");
            return (Criteria) this;
        }

        public Criteria andBankcodeLessThan(String value) {
            addCriterion("BankCode <", value, "bankcode");
            return (Criteria) this;
        }

        public Criteria andBankcodeLessThanOrEqualTo(String value) {
            addCriterion("BankCode <=", value, "bankcode");
            return (Criteria) this;
        }

        public Criteria andBankcodeLike(String value) {
            addCriterion("BankCode like", value, "bankcode");
            return (Criteria) this;
        }

        public Criteria andBankcodeNotLike(String value) {
            addCriterion("BankCode not like", value, "bankcode");
            return (Criteria) this;
        }

        public Criteria andBankcodeIn(List<String> values) {
            addCriterion("BankCode in", values, "bankcode");
            return (Criteria) this;
        }

        public Criteria andBankcodeNotIn(List<String> values) {
            addCriterion("BankCode not in", values, "bankcode");
            return (Criteria) this;
        }

        public Criteria andBankcodeBetween(String value1, String value2) {
            addCriterion("BankCode between", value1, value2, "bankcode");
            return (Criteria) this;
        }

        public Criteria andBankcodeNotBetween(String value1, String value2) {
            addCriterion("BankCode not between", value1, value2, "bankcode");
            return (Criteria) this;
        }

        public Criteria andBankcodingIsNull() {
            addCriterion("BankCoding is null");
            return (Criteria) this;
        }

        public Criteria andBankcodingIsNotNull() {
            addCriterion("BankCoding is not null");
            return (Criteria) this;
        }

        public Criteria andBankcodingEqualTo(String value) {
            addCriterion("BankCoding =", value, "bankcoding");
            return (Criteria) this;
        }

        public Criteria andBankcodingNotEqualTo(String value) {
            addCriterion("BankCoding <>", value, "bankcoding");
            return (Criteria) this;
        }

        public Criteria andBankcodingGreaterThan(String value) {
            addCriterion("BankCoding >", value, "bankcoding");
            return (Criteria) this;
        }

        public Criteria andBankcodingGreaterThanOrEqualTo(String value) {
            addCriterion("BankCoding >=", value, "bankcoding");
            return (Criteria) this;
        }

        public Criteria andBankcodingLessThan(String value) {
            addCriterion("BankCoding <", value, "bankcoding");
            return (Criteria) this;
        }

        public Criteria andBankcodingLessThanOrEqualTo(String value) {
            addCriterion("BankCoding <=", value, "bankcoding");
            return (Criteria) this;
        }

        public Criteria andBankcodingLike(String value) {
            addCriterion("BankCoding like", value, "bankcoding");
            return (Criteria) this;
        }

        public Criteria andBankcodingNotLike(String value) {
            addCriterion("BankCoding not like", value, "bankcoding");
            return (Criteria) this;
        }

        public Criteria andBankcodingIn(List<String> values) {
            addCriterion("BankCoding in", values, "bankcoding");
            return (Criteria) this;
        }

        public Criteria andBankcodingNotIn(List<String> values) {
            addCriterion("BankCoding not in", values, "bankcoding");
            return (Criteria) this;
        }

        public Criteria andBankcodingBetween(String value1, String value2) {
            addCriterion("BankCoding between", value1, value2, "bankcoding");
            return (Criteria) this;
        }

        public Criteria andBankcodingNotBetween(String value1, String value2) {
            addCriterion("BankCoding not between", value1, value2, "bankcoding");
            return (Criteria) this;
        }

        public Criteria andProvinceIsNull() {
            addCriterion("Province is null");
            return (Criteria) this;
        }

        public Criteria andProvinceIsNotNull() {
            addCriterion("Province is not null");
            return (Criteria) this;
        }

        public Criteria andProvinceEqualTo(String value) {
            addCriterion("Province =", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotEqualTo(String value) {
            addCriterion("Province <>", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceGreaterThan(String value) {
            addCriterion("Province >", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceGreaterThanOrEqualTo(String value) {
            addCriterion("Province >=", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLessThan(String value) {
            addCriterion("Province <", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLessThanOrEqualTo(String value) {
            addCriterion("Province <=", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLike(String value) {
            addCriterion("Province like", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotLike(String value) {
            addCriterion("Province not like", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceIn(List<String> values) {
            addCriterion("Province in", values, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotIn(List<String> values) {
            addCriterion("Province not in", values, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceBetween(String value1, String value2) {
            addCriterion("Province between", value1, value2, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotBetween(String value1, String value2) {
            addCriterion("Province not between", value1, value2, "province");
            return (Criteria) this;
        }

        public Criteria andCityIsNull() {
            addCriterion("City is null");
            return (Criteria) this;
        }

        public Criteria andCityIsNotNull() {
            addCriterion("City is not null");
            return (Criteria) this;
        }

        public Criteria andCityEqualTo(String value) {
            addCriterion("City =", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotEqualTo(String value) {
            addCriterion("City <>", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThan(String value) {
            addCriterion("City >", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThanOrEqualTo(String value) {
            addCriterion("City >=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThan(String value) {
            addCriterion("City <", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThanOrEqualTo(String value) {
            addCriterion("City <=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLike(String value) {
            addCriterion("City like", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotLike(String value) {
            addCriterion("City not like", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityIn(List<String> values) {
            addCriterion("City in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotIn(List<String> values) {
            addCriterion("City not in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityBetween(String value1, String value2) {
            addCriterion("City between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotBetween(String value1, String value2) {
            addCriterion("City not between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andCountyIsNull() {
            addCriterion("County is null");
            return (Criteria) this;
        }

        public Criteria andCountyIsNotNull() {
            addCriterion("County is not null");
            return (Criteria) this;
        }

        public Criteria andCountyEqualTo(String value) {
            addCriterion("County =", value, "county");
            return (Criteria) this;
        }

        public Criteria andCountyNotEqualTo(String value) {
            addCriterion("County <>", value, "county");
            return (Criteria) this;
        }

        public Criteria andCountyGreaterThan(String value) {
            addCriterion("County >", value, "county");
            return (Criteria) this;
        }

        public Criteria andCountyGreaterThanOrEqualTo(String value) {
            addCriterion("County >=", value, "county");
            return (Criteria) this;
        }

        public Criteria andCountyLessThan(String value) {
            addCriterion("County <", value, "county");
            return (Criteria) this;
        }

        public Criteria andCountyLessThanOrEqualTo(String value) {
            addCriterion("County <=", value, "county");
            return (Criteria) this;
        }

        public Criteria andCountyLike(String value) {
            addCriterion("County like", value, "county");
            return (Criteria) this;
        }

        public Criteria andCountyNotLike(String value) {
            addCriterion("County not like", value, "county");
            return (Criteria) this;
        }

        public Criteria andCountyIn(List<String> values) {
            addCriterion("County in", values, "county");
            return (Criteria) this;
        }

        public Criteria andCountyNotIn(List<String> values) {
            addCriterion("County not in", values, "county");
            return (Criteria) this;
        }

        public Criteria andCountyBetween(String value1, String value2) {
            addCriterion("County between", value1, value2, "county");
            return (Criteria) this;
        }

        public Criteria andCountyNotBetween(String value1, String value2) {
            addCriterion("County not between", value1, value2, "county");
            return (Criteria) this;
        }

        public Criteria andAddressIsNull() {
            addCriterion("Address is null");
            return (Criteria) this;
        }

        public Criteria andAddressIsNotNull() {
            addCriterion("Address is not null");
            return (Criteria) this;
        }

        public Criteria andAddressEqualTo(String value) {
            addCriterion("Address =", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotEqualTo(String value) {
            addCriterion("Address <>", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThan(String value) {
            addCriterion("Address >", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThanOrEqualTo(String value) {
            addCriterion("Address >=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThan(String value) {
            addCriterion("Address <", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThanOrEqualTo(String value) {
            addCriterion("Address <=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLike(String value) {
            addCriterion("Address like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotLike(String value) {
            addCriterion("Address not like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressIn(List<String> values) {
            addCriterion("Address in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotIn(List<String> values) {
            addCriterion("Address not in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressBetween(String value1, String value2) {
            addCriterion("Address between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotBetween(String value1, String value2) {
            addCriterion("Address not between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andValidityIsNull() {
            addCriterion("Validity is null");
            return (Criteria) this;
        }

        public Criteria andValidityIsNotNull() {
            addCriterion("Validity is not null");
            return (Criteria) this;
        }

        public Criteria andValidityEqualTo(Integer value) {
            addCriterion("Validity =", value, "validity");
            return (Criteria) this;
        }

        public Criteria andValidityNotEqualTo(Integer value) {
            addCriterion("Validity <>", value, "validity");
            return (Criteria) this;
        }

        public Criteria andValidityGreaterThan(Integer value) {
            addCriterion("Validity >", value, "validity");
            return (Criteria) this;
        }

        public Criteria andValidityGreaterThanOrEqualTo(Integer value) {
            addCriterion("Validity >=", value, "validity");
            return (Criteria) this;
        }

        public Criteria andValidityLessThan(Integer value) {
            addCriterion("Validity <", value, "validity");
            return (Criteria) this;
        }

        public Criteria andValidityLessThanOrEqualTo(Integer value) {
            addCriterion("Validity <=", value, "validity");
            return (Criteria) this;
        }

        public Criteria andValidityIn(List<Integer> values) {
            addCriterion("Validity in", values, "validity");
            return (Criteria) this;
        }

        public Criteria andValidityNotIn(List<Integer> values) {
            addCriterion("Validity not in", values, "validity");
            return (Criteria) this;
        }

        public Criteria andValidityBetween(Integer value1, Integer value2) {
            addCriterion("Validity between", value1, value2, "validity");
            return (Criteria) this;
        }

        public Criteria andValidityNotBetween(Integer value1, Integer value2) {
            addCriterion("Validity not between", value1, value2, "validity");
            return (Criteria) this;
        }

        public Criteria andCvv2IsNull() {
            addCriterion("Cvv2 is null");
            return (Criteria) this;
        }

        public Criteria andCvv2IsNotNull() {
            addCriterion("Cvv2 is not null");
            return (Criteria) this;
        }

        public Criteria andCvv2EqualTo(String value) {
            addCriterion("Cvv2 =", value, "cvv2");
            return (Criteria) this;
        }

        public Criteria andCvv2NotEqualTo(String value) {
            addCriterion("Cvv2 <>", value, "cvv2");
            return (Criteria) this;
        }

        public Criteria andCvv2GreaterThan(String value) {
            addCriterion("Cvv2 >", value, "cvv2");
            return (Criteria) this;
        }

        public Criteria andCvv2GreaterThanOrEqualTo(String value) {
            addCriterion("Cvv2 >=", value, "cvv2");
            return (Criteria) this;
        }

        public Criteria andCvv2LessThan(String value) {
            addCriterion("Cvv2 <", value, "cvv2");
            return (Criteria) this;
        }

        public Criteria andCvv2LessThanOrEqualTo(String value) {
            addCriterion("Cvv2 <=", value, "cvv2");
            return (Criteria) this;
        }

        public Criteria andCvv2Like(String value) {
            addCriterion("Cvv2 like", value, "cvv2");
            return (Criteria) this;
        }

        public Criteria andCvv2NotLike(String value) {
            addCriterion("Cvv2 not like", value, "cvv2");
            return (Criteria) this;
        }

        public Criteria andCvv2In(List<String> values) {
            addCriterion("Cvv2 in", values, "cvv2");
            return (Criteria) this;
        }

        public Criteria andCvv2NotIn(List<String> values) {
            addCriterion("Cvv2 not in", values, "cvv2");
            return (Criteria) this;
        }

        public Criteria andCvv2Between(String value1, String value2) {
            addCriterion("Cvv2 between", value1, value2, "cvv2");
            return (Criteria) this;
        }

        public Criteria andCvv2NotBetween(String value1, String value2) {
            addCriterion("Cvv2 not between", value1, value2, "cvv2");
            return (Criteria) this;
        }

        public Criteria andBanktypeIsNull() {
            addCriterion("BankType is null");
            return (Criteria) this;
        }

        public Criteria andBanktypeIsNotNull() {
            addCriterion("BankType is not null");
            return (Criteria) this;
        }

        public Criteria andBanktypeEqualTo(Integer value) {
            addCriterion("BankType =", value, "banktype");
            return (Criteria) this;
        }

        public Criteria andBanktypeNotEqualTo(Integer value) {
            addCriterion("BankType <>", value, "banktype");
            return (Criteria) this;
        }

        public Criteria andBanktypeGreaterThan(Integer value) {
            addCriterion("BankType >", value, "banktype");
            return (Criteria) this;
        }

        public Criteria andBanktypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("BankType >=", value, "banktype");
            return (Criteria) this;
        }

        public Criteria andBanktypeLessThan(Integer value) {
            addCriterion("BankType <", value, "banktype");
            return (Criteria) this;
        }

        public Criteria andBanktypeLessThanOrEqualTo(Integer value) {
            addCriterion("BankType <=", value, "banktype");
            return (Criteria) this;
        }

        public Criteria andBanktypeIn(List<Integer> values) {
            addCriterion("BankType in", values, "banktype");
            return (Criteria) this;
        }

        public Criteria andBanktypeNotIn(List<Integer> values) {
            addCriterion("BankType not in", values, "banktype");
            return (Criteria) this;
        }

        public Criteria andBanktypeBetween(Integer value1, Integer value2) {
            addCriterion("BankType between", value1, value2, "banktype");
            return (Criteria) this;
        }

        public Criteria andBanktypeNotBetween(Integer value1, Integer value2) {
            addCriterion("BankType not between", value1, value2, "banktype");
            return (Criteria) this;
        }

        public Criteria andAuthordernoIsNull() {
            addCriterion("AuthOrderNo is null");
            return (Criteria) this;
        }

        public Criteria andAuthordernoIsNotNull() {
            addCriterion("AuthOrderNo is not null");
            return (Criteria) this;
        }

        public Criteria andAuthordernoEqualTo(String value) {
            addCriterion("AuthOrderNo =", value, "authorderno");
            return (Criteria) this;
        }

        public Criteria andAuthordernoNotEqualTo(String value) {
            addCriterion("AuthOrderNo <>", value, "authorderno");
            return (Criteria) this;
        }

        public Criteria andAuthordernoGreaterThan(String value) {
            addCriterion("AuthOrderNo >", value, "authorderno");
            return (Criteria) this;
        }

        public Criteria andAuthordernoGreaterThanOrEqualTo(String value) {
            addCriterion("AuthOrderNo >=", value, "authorderno");
            return (Criteria) this;
        }

        public Criteria andAuthordernoLessThan(String value) {
            addCriterion("AuthOrderNo <", value, "authorderno");
            return (Criteria) this;
        }

        public Criteria andAuthordernoLessThanOrEqualTo(String value) {
            addCriterion("AuthOrderNo <=", value, "authorderno");
            return (Criteria) this;
        }

        public Criteria andAuthordernoLike(String value) {
            addCriterion("AuthOrderNo like", value, "authorderno");
            return (Criteria) this;
        }

        public Criteria andAuthordernoNotLike(String value) {
            addCriterion("AuthOrderNo not like", value, "authorderno");
            return (Criteria) this;
        }

        public Criteria andAuthordernoIn(List<String> values) {
            addCriterion("AuthOrderNo in", values, "authorderno");
            return (Criteria) this;
        }

        public Criteria andAuthordernoNotIn(List<String> values) {
            addCriterion("AuthOrderNo not in", values, "authorderno");
            return (Criteria) this;
        }

        public Criteria andAuthordernoBetween(String value1, String value2) {
            addCriterion("AuthOrderNo between", value1, value2, "authorderno");
            return (Criteria) this;
        }

        public Criteria andAuthordernoNotBetween(String value1, String value2) {
            addCriterion("AuthOrderNo not between", value1, value2, "authorderno");
            return (Criteria) this;
        }

        public Criteria andUsernoIsNull() {
            addCriterion("UserNo is null");
            return (Criteria) this;
        }

        public Criteria andUsernoIsNotNull() {
            addCriterion("UserNo is not null");
            return (Criteria) this;
        }

        public Criteria andUsernoEqualTo(String value) {
            addCriterion("UserNo =", value, "userno");
            return (Criteria) this;
        }

        public Criteria andUsernoNotEqualTo(String value) {
            addCriterion("UserNo <>", value, "userno");
            return (Criteria) this;
        }

        public Criteria andUsernoGreaterThan(String value) {
            addCriterion("UserNo >", value, "userno");
            return (Criteria) this;
        }

        public Criteria andUsernoGreaterThanOrEqualTo(String value) {
            addCriterion("UserNo >=", value, "userno");
            return (Criteria) this;
        }

        public Criteria andUsernoLessThan(String value) {
            addCriterion("UserNo <", value, "userno");
            return (Criteria) this;
        }

        public Criteria andUsernoLessThanOrEqualTo(String value) {
            addCriterion("UserNo <=", value, "userno");
            return (Criteria) this;
        }

        public Criteria andUsernoLike(String value) {
            addCriterion("UserNo like", value, "userno");
            return (Criteria) this;
        }

        public Criteria andUsernoNotLike(String value) {
            addCriterion("UserNo not like", value, "userno");
            return (Criteria) this;
        }

        public Criteria andUsernoIn(List<String> values) {
            addCriterion("UserNo in", values, "userno");
            return (Criteria) this;
        }

        public Criteria andUsernoNotIn(List<String> values) {
            addCriterion("UserNo not in", values, "userno");
            return (Criteria) this;
        }

        public Criteria andUsernoBetween(String value1, String value2) {
            addCriterion("UserNo between", value1, value2, "userno");
            return (Criteria) this;
        }

        public Criteria andUsernoNotBetween(String value1, String value2) {
            addCriterion("UserNo not between", value1, value2, "userno");
            return (Criteria) this;
        }

        public Criteria andConfignoIsNull() {
            addCriterion("ConfigNo is null");
            return (Criteria) this;
        }

        public Criteria andConfignoIsNotNull() {
            addCriterion("ConfigNo is not null");
            return (Criteria) this;
        }

        public Criteria andConfignoEqualTo(String value) {
            addCriterion("ConfigNo =", value, "configno");
            return (Criteria) this;
        }

        public Criteria andConfignoNotEqualTo(String value) {
            addCriterion("ConfigNo <>", value, "configno");
            return (Criteria) this;
        }

        public Criteria andConfignoGreaterThan(String value) {
            addCriterion("ConfigNo >", value, "configno");
            return (Criteria) this;
        }

        public Criteria andConfignoGreaterThanOrEqualTo(String value) {
            addCriterion("ConfigNo >=", value, "configno");
            return (Criteria) this;
        }

        public Criteria andConfignoLessThan(String value) {
            addCriterion("ConfigNo <", value, "configno");
            return (Criteria) this;
        }

        public Criteria andConfignoLessThanOrEqualTo(String value) {
            addCriterion("ConfigNo <=", value, "configno");
            return (Criteria) this;
        }

        public Criteria andConfignoLike(String value) {
            addCriterion("ConfigNo like", value, "configno");
            return (Criteria) this;
        }

        public Criteria andConfignoNotLike(String value) {
            addCriterion("ConfigNo not like", value, "configno");
            return (Criteria) this;
        }

        public Criteria andConfignoIn(List<String> values) {
            addCriterion("ConfigNo in", values, "configno");
            return (Criteria) this;
        }

        public Criteria andConfignoNotIn(List<String> values) {
            addCriterion("ConfigNo not in", values, "configno");
            return (Criteria) this;
        }

        public Criteria andConfignoBetween(String value1, String value2) {
            addCriterion("ConfigNo between", value1, value2, "configno");
            return (Criteria) this;
        }

        public Criteria andConfignoNotBetween(String value1, String value2) {
            addCriterion("ConfigNo not between", value1, value2, "configno");
            return (Criteria) this;
        }

        public Criteria andConfirmstatusIsNull() {
            addCriterion("ConfirmStatus is null");
            return (Criteria) this;
        }

        public Criteria andConfirmstatusIsNotNull() {
            addCriterion("ConfirmStatus is not null");
            return (Criteria) this;
        }

        public Criteria andConfirmstatusEqualTo(Integer value) {
            addCriterion("ConfirmStatus =", value, "confirmstatus");
            return (Criteria) this;
        }

        public Criteria andConfirmstatusNotEqualTo(Integer value) {
            addCriterion("ConfirmStatus <>", value, "confirmstatus");
            return (Criteria) this;
        }

        public Criteria andConfirmstatusGreaterThan(Integer value) {
            addCriterion("ConfirmStatus >", value, "confirmstatus");
            return (Criteria) this;
        }

        public Criteria andConfirmstatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("ConfirmStatus >=", value, "confirmstatus");
            return (Criteria) this;
        }

        public Criteria andConfirmstatusLessThan(Integer value) {
            addCriterion("ConfirmStatus <", value, "confirmstatus");
            return (Criteria) this;
        }

        public Criteria andConfirmstatusLessThanOrEqualTo(Integer value) {
            addCriterion("ConfirmStatus <=", value, "confirmstatus");
            return (Criteria) this;
        }

        public Criteria andConfirmstatusIn(List<Integer> values) {
            addCriterion("ConfirmStatus in", values, "confirmstatus");
            return (Criteria) this;
        }

        public Criteria andConfirmstatusNotIn(List<Integer> values) {
            addCriterion("ConfirmStatus not in", values, "confirmstatus");
            return (Criteria) this;
        }

        public Criteria andConfirmstatusBetween(Integer value1, Integer value2) {
            addCriterion("ConfirmStatus between", value1, value2, "confirmstatus");
            return (Criteria) this;
        }

        public Criteria andConfirmstatusNotBetween(Integer value1, Integer value2) {
            addCriterion("ConfirmStatus not between", value1, value2, "confirmstatus");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNull() {
            addCriterion("CreateTime is null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNotNull() {
            addCriterion("CreateTime is not null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeEqualTo(Date value) {
            addCriterion("CreateTime =", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotEqualTo(Date value) {
            addCriterion("CreateTime <>", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThan(Date value) {
            addCriterion("CreateTime >", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThanOrEqualTo(Date value) {
            addCriterion("CreateTime >=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThan(Date value) {
            addCriterion("CreateTime <", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThanOrEqualTo(Date value) {
            addCriterion("CreateTime <=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIn(List<Date> values) {
            addCriterion("CreateTime in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotIn(List<Date> values) {
            addCriterion("CreateTime not in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeBetween(Date value1, Date value2) {
            addCriterion("CreateTime between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotBetween(Date value1, Date value2) {
            addCriterion("CreateTime not between", value1, value2, "createtime");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}